using System;
using System.Collections;
using CE.Database;
/// <summary>
/// Summary description for UserProfileDB
/// </summary>
/// 
namespace CE.HomeRefinance
{
    public class HFContactDB
    {
        public HFContactDB()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public Int64 Insert(HFContact contact)
        {
            MyDatabase _db = new MyDatabase();
            Int64 _result = -1;
            string _spName = "[sprocHFContactInsertUpdateSingleItem]";
            
            SortedList _sPara = new SortedList();
            
            #region Parameter
               _sPara.Add("@HFContactID", contact.HFContactID);
		       _sPara.Add("@HFPersonnelID", contact.HFPersonnelID);
               _sPara.Add("@HFEmail", contact.HFEmailAddress);
               _sPara.Add("@HFMobilePhoneNo", contact.HFMobilePhoneNo);
               _sPara.Add("@HFOfficePhoneNo", contact.HFOfficePhoneNo);
               _sPara.Add("@HFHomePhoneNo", contact.HFHomePhoneNo);
               _sPara.Add("@HFPostCode", contact.HFPostCode);
               _sPara.Add("@HFBHNo", contact.HFBHNo);
               _sPara.Add("@HFHomeNo", contact.HFHomeNo);
               _sPara.Add("@HFStreetName", contact.HFStreetName);
               _sPara.Add("@HFYearsThere", contact.HFYearsThere);
               _sPara.Add("@HFMailPostCode", contact.HFMailPostCode);
               _sPara.Add("@HFMailBHNo", contact.HFMailBHNo);
               _sPara.Add("@HFMailHomeNo", contact.HFMailHomeNo);
               _sPara.Add("@HFMailStreetName", contact.HFMailStreetName);
               _sPara.Add("@HFEmContact", contact.HFEmContactNo);
               _sPara.Add("@HFEmContactNo", contact.HFEmContactNo);
               _sPara.Add("@HFEmRelationship", contact.HFEmRelationship);
               _sPara.Add("@HFIsMainBorrower", contact.HFIsMainBorrower);
               _sPara.Add("@ViewedDetailId", contact.ViewedDetailId);
                _sPara.Add("@Status", contact.Status);
                _sPara.Add("@Info1", contact.Info1);
                _sPara.Add("@Info2", contact.Info2);
                _sPara.Add("@Info3", contact.Info3);
                _sPara.Add("@Info4", contact.Info4);
                _sPara.Add("@Info5", contact.Info5);
                _sPara.Add("@Info6", contact.Info6);
                _sPara.Add("@Info7", contact.Info7);
                _sPara.Add("@Info8", contact.Info8);
                _sPara.Add("@Info9", contact.Info9);
                _sPara.Add("@Info10", contact.Info10);
                _sPara.Add("@Info11", contact.Info11);
                _sPara.Add("@Info12", contact.Info12);
                _sPara.Add("@Info13", contact.Info13);
                _sPara.Add("@Info14", contact.Info14);
                _sPara.Add("@Info15", contact.Info15);
                _sPara.Add("@Info16", contact.Info16);
                _sPara.Add("@Info17", contact.Info17);
                _sPara.Add("@Info18", contact.Info18);
                _sPara.Add("@Info19", contact.Info19);
                _sPara.Add("@Info20", contact.Info20);
            #endregion

            _result = _db.ExecuteSP(_spName, _sPara);

            return _result;
        }

        public bool Update()
        {
            return true;
        }

        public bool Delete()
        {
            return true;
        }
        
    }
}